Dashboard 02 - Create a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller 18


Next, we will create a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller


Step 1 - Download Scroller Visual

In Power BI Desktop, click on the page, RaleighPoliceIncidents-District

If you don't see the Scroller Visualizations  under Visualizations, follow these steps to add it.


Under Visualizations, click on the Ellipsis  (...) ->  Import a Visual from a file ->  browse to the extracted folder ->  template and select the visualization, Scroller.2.0.3.0.pbiviz

When it is installed successfully, you will now see the Scroller visualizations icon under Visualizations.



Step 2 - Create  a Year Over Year (YOY) Violent Crimes and Crimes Rate by District Scroller

Visualizations

Click the Scroller icon

Fields

Select the following:

A_KeyMeasures ->  .Total_Violent_Crimes  - Under Visualizations, drag & drop it in the Measure Absolute section.

A_KeyMeasures ->  .YOY_Violent_CrimeRate%  - Under Visualizations, drag & drop it in the Measure Deviation section.

Raleigh_Police_Incidents_NIBRS ->  District - Under Visualizations, drag & drop it in the Category section


Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Violent_Crimes = Total Violent Crimes

.YOY_Violent_CrimeRate% = YOY Violent Crime Rate

District = District Name



Format tab

Under Format ->  General: X Position = 360 , Y Position = 947 , Width = 1039 , Height = 53

Under Format ->  Scroller -> Set Status Indicator to ON ->  Font Size = 18 , Scroll Speed = 1 , TextColor = FFFFFF , Background Color = 094780 , Update Interval = 50

Under Format -> Title ->  Set it to ON , Title Text = Year Over Year (YOY) Violent Crimes and Crimes Rate by District , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 15 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666




Filters

None




When finished, save project.


For more information on the Scrollers or to download the Scroller used in this project:


Scroller